package sg.edu.nus.iss.phoenix.core.dao;

/**
 * @author Swaminathan Subramanian (A0076756)
 * @version 1.0 2012/9/26
 */
public class DBConstants {
	
	// Data Connection Variables
	public static final String COM_MYSQL_JDBC_DRIVER = "com.mysql.jdbc.Driver";
	public static final String dbUrl = "jdbc:mysql://127.0.0.1/phoenix1";
			//"jdbc:mysql://localhost:3306/phoenix";
	public static final String dbUserName = "team5s";
	public static final String dbPassword = "iss";
	 	
	// Table names
    public static final String usersTableName = "user";
    public static final String rolesTableName = "role";
   
    
    
    //Users table field names
    public static final String u_id = "user_id";
    public static final String u_name = "username";
    public static final String u_password = "password";
    public static final String u_firstName = "first_name";
    public static final String u_lastName = "last_name";
    public static final String u_role ="role";

    //roles table field names
    public static final String r_role = "role";
    public static final String r_access ="accessPrivilege";
    



}
